﻿CREATE TABLE [dbo].[PipelineStep] (
    [PipelineStepID]           UNIQUEIDENTIFIER NOT NULL,
    [PipelineID]               UNIQUEIDENTIFIER NULL,
    [ParentStepID]             UNIQUEIDENTIFIER NULL,
    [LayerID]                  UNIQUEIDENTIFIER NULL,
    [Name]                     VARCHAR (50)     NULL,
    [DefaultLayerStepOridinal] INT              NULL,
    [RequiredLayerStepOrdinal] INT              NULL,
    [Description]              TEXT             NULL,
    [StepAssembly]             NVARCHAR (MAX)   NULL
);

